OpenEdge Data Management:<br />SQL Reference DhSQLResultSet.makeNULL

Release 10.1A: OpenEdge Data Management:
SQL Reference

DhSQLResultSet.makeNULL

Sets a field of the currently active row in a procedure’s result set to NULL. This method is redundant with using the DhSQLResultSet.set method to set a procedure result-set field to NULL.

Format

public void makeNULL(int field)

Returns

None

Parameters
field
An integer that specifies which field of the result-set row to set to NULL. 1 denotes the first field in the row, 2 denotes the second, n denotes the nth.

Throws

DhSQLException
Example

This code fragment illustrates SQLResultSet.set and SQLResultSet.makeNULL:
CREATE PROCEDURE test_makeNULL2(
    IN char_in CHAR(20) 
RESULT ( res_char CHAR(20) , res_vchar VARCHAR(30))
 
BEGIN
    SQLResultSet.set(1,char_in);
    SQLResultSet.makeNULL(2);
END 